load data
truncate                                       
into table CRST_PO_REQUISITION_HEADERS_AL
fields terminated by "	"                      
trailing nullcols 
( REQUISITION_HEADER_ID      ,
  PREPARER_ID                ,
  LAST_UPDATE_DATE           Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY            ,
  SEGMENT1                   ,
  SUMMARY_FLAG               ,
  ENABLED_FLAG               ,
  SEGMENT2                   ,
  SEGMENT3                   ,
  SEGMENT4                   ,
  SEGMENT5                   ,
  START_DATE_ACTIVE          Date "YYYYMMDD HH24:MI:SS",
  END_DATE_ACTIVE            Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATE_LOGIN          ,
  CREATION_DATE              Date "YYYYMMDD HH24:MI:SS",
  CREATED_BY                 ,
  DESCRIPTION                ,
  AUTHORIZATION_STATUS       ,
  NOTE_TO_AUTHORIZER         ,
  TYPE_LOOKUP_CODE           ,
  TRANSFERRED_TO_OE_FLAG     ,
  ATTRIBUTE_CATEGORY         ,
  ATTRIBUTE1                 ,
  ATTRIBUTE2                 ,
  ATTRIBUTE3                 ,
  ATTRIBUTE4                 ,
  ATTRIBUTE5                 ,
  ON_LINE_FLAG               ,
  PRELIMINARY_RESEARCH_FLAG  ,
  RESEARCH_COMPLETE_FLAG     ,
  PREPARER_FINISHED_FLAG     ,
  PREPARER_FINISHED_DATE     Date "YYYYMMDD HH24:MI:SS",
  AGENT_RETURN_FLAG          ,
  AGENT_RETURN_NOTE          ,
  CANCEL_FLAG                ,
  ATTRIBUTE6                 ,
  ATTRIBUTE7                 ,
  ATTRIBUTE8                 ,
  ATTRIBUTE9                 ,
  ATTRIBUTE10                ,
  ATTRIBUTE11                ,
  ATTRIBUTE12                ,
  ATTRIBUTE13                ,
  ATTRIBUTE14                ,
  ATTRIBUTE15                ,
  USSGL_TRANSACTION_CODE     ,
  GOVERNMENT_CONTEXT         ,
  REQUEST_ID                 ,
  PROGRAM_APPLICATION_ID     ,
  PROGRAM_ID                 ,
  PROGRAM_UPDATE_DATE        Date "YYYYMMDD HH24:MI:SS",
  INTERFACE_SOURCE_CODE      ,
  INTERFACE_SOURCE_LINE_ID   ,
  CLOSED_CODE                ,
  ORG_ID                     ,
  WF_ITEM_TYPE               ,
  WF_ITEM_KEY                ,
  EMERGENCY_PO_NUM           ,
  PCARD_ID                   ,
  APPS_SOURCE_CODE           ,
  CBC_ACCOUNTING_DATE        Date "YYYYMMDD HH24:MI:SS",
  CHANGE_PENDING_FLAG        
)
